/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package cn.com.jsepc.rep.report;

import cn.com.jsepc.rep.comm.ConstUtil;
import com.jarp.db.DAO;
import java.util.Hashtable;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;

/**
 *
 * @author yuan
 */
public class DeleteFactIsNull {

    public String DeleteNullFact() {
        DAO dao = new DAO();
        String SQL = "SELECT t.REPID,t.REFFACT FROM tb_report t WHERE t.SOURCETYPE=2 AND t.REFFACT is NOT NULL";
        try {
            Vector v = dao.getDataSet(ConstUtil.DBNAME, SQL);
            if (v != null) {
                for (int i = 0; i < v.size(); i++) {
                    Hashtable hash = (Hashtable) v.get(i);
                    String reffact = (String) hash.get("REFFACT");  //事实表表名
                    String repid = (String) hash.get("REPID");       //指标编码
                    
                }
            }
        } catch (ServletException ex) {
            Logger.getLogger(DeleteFactIsNull.class.getName()).log(Level.SEVERE, null, ex);
        }
        return "";
    }
}
